eg:
before:
- apple a1 3
a2 10
sub 13
- orange a1 9
a2 3
sub 12
after:
+ apple
sub 13
+ orange
sub 12
-Anders
i think you're looking for =subtotal() function in excel. if i'm right,
then you have to use excel automation by reading each record in the table
then insert a =subtotal() when the group changes.
hope this would help...
allan